package com.ihr360.oneclick.dao;

import com.ihr360.oneclick.dto.spreadsheet.SpreadsheetDto;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;

import java.util.List;

/**
 *
 * @author tom
 * @date 17-12-19
 */
public interface SpreadsheetDao extends JpaRepository<SpreadsheetDto, String>, JpaSpecificationExecutor<SpreadsheetDto> {

    List<SpreadsheetDto> findByIdIn(List<String> idList);

    List<SpreadsheetDto> findByTermId(String termId);

    @Modifying
    void deleteByIdIn(List<String> idList);

}
